LOAD DATA 
 INFILE mejoras_ajenas.dat
 TRUNCATE
 CONTINUEIF NEXT(1:1) = '#'
 INTO TABLE MEJORAS_AJENAS
 FIELDS TERMINATED BY '|'
 TRAILING NULLCOLS (
   chip 	NULLIF chip = BLANKS,
   valorm2,
   area,
   fec_reg DATE "YYYYMMDD",
   id_fun,
   GEO COLUMN OBJECT 
   (
     SDO_GTYPE       INTEGER EXTERNAL, 
     SDO_ELEM_INFO   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL), 
     SDO_ORDINATES   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL) 
   )
)
